﻿/*CREATE TABLE [dbo].[ChamberDocuments] (
    [Id]                                                      NVARCHAR (100) NOT NULL,
    [Chamber]                                                 NVARCHAR (MAX) NOT NULL,
    [Title]                                                   NVARCHAR (MAX) NOT NULL,
    [IndexedContent]                                          NVARCHAR (MAX) NOT NULL,
    [Date]                                                    DATETIME       NOT NULL,
    [DocumentType]                                            NVARCHAR (MAX) NOT NULL,
    [DocumentPDFLink]                                         NVARCHAR (MAX) NULL,
    [Summary]                                                 NVARCHAR (MAX) NULL,
    [SectionXML]                                              NVARCHAR (MAX) NOT NULL,
    [DocumentHTMLLink]                                        NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]                                        INT            NOT NULL,
    [DocumentNumber]                                          NVARCHAR (MAX) NOT NULL,
    [SequenceNumber]                                          INT            NULL,
    [PageNumber]                                              INT            NULL,
    [TOC_Id]                                                  NVARCHAR (100) NULL,
    [ChamberDocumentSearchChamberDocument_ChamberDocument_Id] NVARCHAR (100) NOT NULL
);*/



